IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tr_ProjectListByEmail_Get]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[tr_ProjectListByEmail_Get]
GO

CREATE PROCEDURE [dbo].[tr_ProjectListByEmail_Get]
AS

SELECT 
	tr_Project.ProjectId,
	tr_Project.Name,
	tr_ProjectSettings.ProjectEmail,
	tr_Project.ActiveInd
	
FROM 
	tr_Project 
	inner join 
		tr_ProjectSettings ON tr_ProjectSettings.ProjectId = tr_Project.ProjectId
WHERE 
	DeletedInd = 0
